1
2 import java.sql.Connection;
3 import java.sql.DriverManager;
4 import java.sql.ResultSet;
5 import java.sql.Statement;
6
7 /*
8 * To change this license header, choose License Headers in Project Properties.
9 * To change this template file, choose Tools | Templates
10 * and open the template in the editor.
11 */
12
13 /**
14 *
15 * @author MY LAPI
16 */
17 public class NewUserReg extends javax.swing.JFrame {
18
19 /**
20 * Creates new form NewUserReg
21 */
22 public NewUserReg() {
23 initComponents();
24 }
25
26 /**
27 * This method is called from within the constructor to initialize the form.
28 * WARNING: Do NOT modify this code. The content of this method is always
29 * regenerated by the Form Editor.
30 */
31 @SuppressWarnings("unchecked")
32 // <editor-fold defaultstate="collapsed" desc="Generated Code">//GEN-BEGIN:initComponents
33 private void initComponents() {
34
35 jLabel1 = new javax.swing.JLabel();
36 jLabel2 = new javax.swing.JLabel();
37 jTextField1 = new javax.swing.JTextField();
38 jTextField2 = new javax.swing.JTextField();
39 jLabel3 = new javax.swing.JLabel();
40 jLabel4 = new javax.swing.JLabel();
41 jTextField3 = new javax.swing.JTextField();
42 jTextField4 = new javax.swing.JTextField();
43 jLabel5 = new javax.swing.JLabel();
44 jLabel6 = new javax.swing.JLabel();
45 jTextField6 = new javax.swing.JTextField();
46 jLabel7 = new javax.swing.JLabel();
47 jTextField7 = new javax.swing.JTextField();
48 jButton1 = new javax.swing.JButton();
49 jButton2 = new javax.swing.JButton();
50 jScrollPane1 = new javax.swing.JScrollPane();
51 jTextArea1 = new javax.swing.JTextArea();
52 jLabel8 = new javax.swing.JLabel();
53 jTextField5 = new javax.swing.JTextField();
54 jLabel9 = new javax.swing.JLabel();
55 jTextField8 = new javax.swing.JTextField();
56 jLabel10 = new javax.swing.JLabel();
57
58 setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);
59
60 jLabel1.setFont(new java.awt.Font("Arial Unicode MS", 0, 24)); // NOI18N
61 jLabel1.setText("User Registration");
62
63 jLabel2.setFont(new java.awt.Font("Arial Unicode MS", 0, 14)); // NOI18N
64 jLabel2.setText("Name");
65
66 jLabel3.setFont(new java.awt.Font("Arial Unicode MS", 0, 14)); // NOI18N
67 jLabel3.setText("Father Name");
68
69 jLabel4.setFont(new java.awt.Font("Arial Unicode MS", 0, 14)); // NOI18N
70 jLabel4.setText("Mother Name");
71
72 jLabel5.setFont(new java.awt.Font("Arial Unicode MS", 0, 14)); // NOI18N
73 jLabel5.setText("Adhar No");
74
75 jLabel6.setFont(new java.awt.Font("Arial Unicode MS", 0, 14)); // NOI18N
76 jLabel6.setText("Address");
77
78 jLabel7.setFont(new java.awt.Font("Arial Unicode MS", 0, 14)); // NOI18N
79 jLabel7.setText("Pen Card");
80
81 jTextField7.addActionListener(new java.awt.event.ActionListener() {
82 public void actionPerformed(java.awt.event.ActionEvent evt) {
83 jTextField7ActionPerformed(evt);
84 }
85 });
86
87 jButton1.setFont(new java.awt.Font("Arial Unicode MS", 0, 14)); // NOI18N
88 jButton1.setText("Reset");
89 jButton1.addActionListener(new java.awt.event.ActionListener() {
90 public void actionPerformed(java.awt.event.ActionEvent evt) {
91 jButton1ActionPerformed(evt);
92 }
93 });
94
95 jButton2.setFont(new java.awt.Font("Arial Unicode MS", 0, 14)); // NOI18N
96 jButton2.setText("Submit");
97 jButton2.addActionListener(new java.awt.event.ActionListener() {
98 public void actionPerformed(java.awt.event.ActionEvent evt) {
99 jButton2ActionPerformed(evt);
100 }
101 });
102
103 jTextArea1.setColumns(20);
104 jTextArea1.setRows(5);
105 jScrollPane1.setViewportView(jTextArea1);
106
107 jLabel8.setFont(new java.awt.Font("Arial Unicode MS", 0, 14)); // NOI18N
108 jLabel8.setText("Email");
109
110 jLabel9.setFont(new java.awt.Font("Arial Unicode MS", 0, 14)); // NOI18N
111 jLabel9.setText("Mobile");
112
113 javax.swing.GroupLayout layout = new javax.swing.GroupLayout(getContentPane());
114 getContentPane().setLayout(layout);
115 layout.setHorizontalGroup(
116 layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
117 .addGroup(layout.createSequentialGroup()
118 .addGap(21, 21, 21)
119 .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
120 .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, layout.createSequentialGroup()
121 .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
122 .addComponent(jLabel8, javax.swing.GroupLayout.PREFERRED_SIZE, 42, javax.swing.GroupLayout.PREFERRED_SIZE)
123 .addComponent(jLabel9, javax.swing.GroupLayout.PREFERRED_SIZE, 42, javax.swing.GroupLayout.PREFERRED_SIZE)
124 .addComponent(jLabel4)
125 .addComponent(jLabel7))
126 .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, 51, Short.MAX_VALUE)
127 .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
128 .addComponent(jTextField8, javax.swing.GroupLayout.PREFERRED_SIZE, 210, javax.swing.GroupLayout.PREFERRED_SIZE)
129 .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false)
130 .addComponent(jTextField4, javax.swing.GroupLayout.DEFAULT_SIZE, 210, Short.MAX_VALUE)
131 .addComponent(jTextField5, javax.swing.GroupLayout.Alignment.TRAILING))
132 .addComponent(jTextField6, javax.swing.GroupLayout.PREFERRED_SIZE, 210, javax.swing.GroupLayout.PREFERRED_SIZE)))
133 .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, layout.createSequentialGroup()
134 .addComponent(jLabel3)
135 .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
136 .addComponent(jTextField3, javax.swing.GroupLayout.PREFERRED_SIZE, 210, javax.swing.GroupLayout.PREFERRED_SIZE))
137 .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, layout.createSequentialGroup()
138 .addComponent(jLabel2, javax.swing.GroupLayout.PREFERRED_SIZE, 48, javax.swing.GroupLayout.PREFERRED_SIZE)
139 .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
140 .addComponent(jTextField1, javax.swing.GroupLayout.PREFERRED_SIZE, 99, javax.swing.GroupLayout.PREFERRED_SIZE)
141 .addGap(18, 18, 18)
142 .addComponent(jTextField2, javax.swing.GroupLayout.PREFERRED_SIZE, 93, javax.swing.GroupLayout.PREFERRED_SIZE))
143 .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, layout.createSequentialGroup()
144 .addComponent(jLabel5)
145 .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
146 .addComponent(jTextField7, javax.swing.GroupLayout.PREFERRED_SIZE, 210, javax.swing.GroupLayout.PREFERRED_SIZE))
147 .addGroup(layout.createSequentialGroup()
148 .addGap(93, 93, 93)
149 .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
150 .addComponent(jLabel1)
151 .addGroup(layout.createSequentialGroup()
152 .addComponent(jButton1)
153 .addGap(46, 46, 46)
154 .addComponent(jButton2))
155 .addGroup(layout.createSequentialGroup()
156 .addGap(10, 10, 10)
157 .addComponent(jLabel10, javax.swing.GroupLayout.PREFERRED_SIZE, 197, javax.swing.GroupLayout.PREFERRED_SIZE)))
158 .addGap(0, 0, Short.MAX_VALUE))
159 .addGroup(layout.createSequentialGroup()
160 .addComponent(jLabel6)
161 .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
162 .addComponent(jScrollPane1, javax.swing.GroupLayout.PREFERRED_SIZE, 210, javax.swing.GroupLayout.PREFERRED_SIZE)))
163 .addGap(32, 32, 32))
164 );
165 layout.setVerticalGroup(
166 layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
167 .addGroup(layout.createSequentialGroup()
168 .addContainerGap()
169 .addComponent(jLabel1)
170 .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
171 .addComponent(jLabel10, javax.swing.GroupLayout.PREFERRED_SIZE, 0, javax.swing.GroupLayout.PREFERRED_SIZE)
172 .addGap(11, 11, 11)
173 .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
174 .addComponent(jTextField2, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
175 .addComponent(jTextField1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
176 .addComponent(jLabel2))
177 .addGap(18, 18, 18)
178 .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
179 .addComponent(jTextField3, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
180 .addComponent(jLabel3))
181 .addGap(19, 19, 19)
182 .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
183 .addComponent(jTextField4, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
184 .addComponent(jLabel4))
185 .addGap(18, 18, 18)
186 .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
187 .addComponent(jTextField8, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
188 .addComponent(jLabel8))
189 .addGap(18, 18, 18)
190 .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
191 .addComponent(jTextField5, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
192 .addComponent(jLabel9))
193 .addGap(18, 18, 18)
194 .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
195 .addComponent(jTextField6, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
196 .addComponent(jLabel7))
197 .addGap(18, 18, 18)
198 .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
199 .addComponent(jLabel5)
200 .addComponent(jTextField7, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
201 .addGap(18, 18, 18)
202 .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
203 .addComponent(jLabel6)
204 .addComponent(jScrollPane1, javax.swing.GroupLayout.PREFERRED_SIZE, 59, javax.swing.GroupLayout.PREFERRED_SIZE))
205 .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, 42, Short.MAX_VALUE)
206 .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
207 .addComponent(jButton2)
208 .addComponent(jButton1))
209 .addContainerGap())
210 );
211
212 pack();
213 }// </editor-fold>//GEN-END:initComponents
214
215 private void jTextField7ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jTextField7ActionPerformed
216
217 }//GEN-LAST:event_jTextField7ActionPerformed
218
219 private void jButton2ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton2ActionPerformed
220 try{
221 Class.forName("com.mysql.jdbc.Driver").newInstance();
222 Connection cn=DriverManager.getConnection("jdbc:mysql://localhost:3306/bank","root","");
223
224 Statement smt=cn.createStatement();
225 String p="insert into user(name,fname,mname,email,mobile,pen,adhar,addr,accno,atm,password) values('"+jTextField1.getText()+""+jTextField2.getText()+"','"+jTextField3.getText()+"','"+jTextField4.getText()+"','"+jTextField8.getText()+"','"+jTextField5.getText()+"','"+jTextField6.getText()+"','"+jTextField7.getText()+"','"+jTextArea1.getText()+"','','','')";
226 smt.executeUpdate(p);
227
228 ResultSet rs=smt.executeQuery("select uid from user where email='"+jTextField8.getText()+"'");
229 int pb=1;
230 if(rs.next()){ pb=rs.getInt(1); }
231 Accgernerator pb1=new Accgernerator(pb);
232 NewUserReg pb2=new NewUserReg();
233 pb2.setVisible(false);
234 pb1.setVisible(true);
235 dispose();
236
237 }catch(Exception e){jLabel10.setText(e.getMessage());}
238 }//GEN-LAST:event_jButton2ActionPerformed
239
240 private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton1ActionPerformed
241 jTextField1.setText("");
242 jTextField2.setText("");
243 jTextField3.setText("");
244 jTextField4.setText("");
245 jTextField8.setText("");
246 jTextField5.setText("");
247 jTextField6.setText("");
248 jTextField7.setText("");
249 jTextArea1.setText("");
250 }//GEN-LAST:event_jButton1ActionPerformed
251
252 /**
253 * @param args the command line arguments
254 */
255 public static void main(String args[]) {
256 /* Set the Nimbus look and feel */
257 //<editor-fold defaultstate="collapsed" desc=" Look and feel setting code (optional) ">
258 /* If Nimbus (introduced in Java SE 6) is not available, stay with the default look and feel.
259 * For details see http://download.oracle.com/javase/tutorial/uiswing/lookandfeel/plaf.html
260 */
261 try {
262 for (javax.swing.UIManager.LookAndFeelInfo info : javax.swing.UIManager.getInstalledLookAndFeels()) {
263 if ("Nimbus".equals(info.getName())) {
264 javax.swing.UIManager.setLookAndFeel(info.getClassName());
265 break;
266 }
267 }
268 } catch (ClassNotFoundException ex) {
269 java.util.logging.Logger.getLogger(NewUserReg.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
270 } catch (InstantiationException ex) {
271 java.util.logging.Logger.getLogger(NewUserReg.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
272 } catch (IllegalAccessException ex) {
273 java.util.logging.Logger.getLogger(NewUserReg.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
274 } catch (javax.swing.UnsupportedLookAndFeelException ex) {
275 java.util.logging.Logger.getLogger(NewUserReg.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
276 }
277 //</editor-fold>
278
279 /* Create and display the form */
280 java.awt.EventQueue.invokeLater(new Runnable() {
281 public void run() {
282 new NewUserReg().setVisible(true);
283 }
284 });
285 }
286
287 // Variables declaration - do not modify//GEN-BEGIN:variables
288 private javax.swing.JButton jButton1;
289 private javax.swing.JButton jButton2;
290 private javax.swing.JLabel jLabel1;
291 private javax.swing.JLabel jLabel10;
292 private javax.swing.JLabel jLabel2;
293 private javax.swing.JLabel jLabel3;
294 private javax.swing.JLabel jLabel4;
295 private javax.swing.JLabel jLabel5;
296 private javax.swing.JLabel jLabel6;
297 private javax.swing.JLabel jLabel7;
298 private javax.swing.JLabel jLabel8;
299 private javax.swing.JLabel jLabel9;
300 private javax.swing.JScrollPane jScrollPane1;
301 private javax.swing.JTextArea jTextArea1;
302 private javax.swing.JTextField jTextField1;
303 private javax.swing.JTextField jTextField2;
304 private javax.swing.JTextField jTextField3;
305 private javax.swing.JTextField jTextField4;
306 private javax.swing.JTextField jTextField5;
307 private javax.swing.JTextField jTextField6;
308 private javax.swing.JTextField jTextField7;
309 private javax.swing.JTextField jTextField8;
310 // End of variables declaration//GEN-END:variables
311 }